#!/bin/bash
USERNAME="root"
PASSWORD="root"
DBNAME="transfusionsystem"

create_db_sql="CREATE SCHEMA `${DBNAME}` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;"
mysql -u${USERNAME} -p${PASSWORD} -e "${create_db_sql}"